package com.fushihua.y2015.m09.d24;

public class Test1 {
	public static void main(String[] args) {
		String sql = 

"SELECT " +
"nvl((SELECT  branchattr FROM tbl_labranchgroup WHERE branchtype='5' AND  tsalegroup=(SELECT upbranch FROM tbl_labranchgroup WHERE tsalegroup = (SELECT upbranch FROM tbl_labranchgroup WHERE tsalegroup =(SELECT tsalegroup FROM tbl_laagent WHERE tsalecode ='5861020006')))),'') a, " + 
"nvl((SELECT  branchattr FROM tbl_labranchgroup WHERE branchtype='5' AND  tsalegroup=(SELECT upbranch FROM tbl_labranchgroup WHERE tsalegroup =(SELECT tsalegroup FROM tbl_laagent WHERE tsalecode ='5861020006'))),'') b, " + 
"nvl((SELECT  branchattr FROM tbl_labranchgroup WHERE branchtype='5' AND  tsalegroup =(SELECT tsalegroup FROM tbl_laagent WHERE tsalecode ='5861020006')),'') c, " + 
"nvl((SELECT  branchlevel FROM tbl_labranchgroup WHERE branchtype='5' AND  tsalegroup =(SELECT tsalegroup FROM tbl_laagent WHERE tsalecode ='5861020006')),'') d " + 
"FROM DUAL ";

	}
}
